sysbench ./zbench_cameras.lua \
 --db-driver=mysql \
 --mysql-user=root \
 --mysql-password=1234 \
 --mysql-host=127.0.0.1 \
 --mysql-port=3306 \
 --mysql-db=benchdb \
 --table-size=5000000 prepare


# 运行测试

#!/bin/bash

THREAD_COUNT=${1:-200}
TEST_SECONDS=${2:-180}

sysbench ./zbench_cameras.lua \
  --db-driver=mysql \
  --mysql-user=root \
  --mysql-password=1234 \
  --mysql-host=127.0.0.1 \
  --mysql-port=3306 \
  --mysql-db=benchdb \
  --table-size=10000 \
  --threads=$THREAD_COUNT \
  --time=$TEST_SECONDS \
  --report-interval=10 \
  run


